import matplotlib.pyplot as plt
import pandas as pd
df = pd.read_excel('1314.xlsx',index_col=0)
plt.rcParams['font.sans-serif']='SimHei'
x=df['总分']
plt.xlabel('姓名')
plt.ylabel('序号')
plt.title('不同价格区间菜品数量分布直方图')
plt.hist(x,bins=10,color=(0.894,0,0.498),edgecolor='k')
plt.show()